package table

//Function table:Function Engine: InnoDB Collation: utf8mb4_general_ci
type Function struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(300);
	Name string
	//Creator field:creator int;
	Creator int
	//Ct field:ct bigint;
	Ct int64
}

//Module table:Module Engine: InnoDB Collation: utf8mb4_general_ci
type Module struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(100);
	Name string
	//Creator field:creator int;
	Creator int
	//Ct field:ct bigint;
	Ct int64
}

//Organization table:Organization Engine: InnoDB Collation: utf8mb4_general_ci
type Organization struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(100);
	Name string
	//Creator field:creator int;
	Creator int
	//Ct field:ct bigint;
	Ct int64
}

//Project table:Project Engine: InnoDB Collation: utf8mb4_general_ci
type Project struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(100);
	Name string
	//Ct field:ct bigint;
	Ct int64
}

//Scrum table:Scrum Engine: InnoDB Collation: utf8mb4_general_ci
type Scrum struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(100);
	Name string
	//Creator field:creator int;
	Creator int
	//Ct field:ct bigint;
	Ct int64
}

//Sprint table:Sprint Engine: InnoDB Collation: utf8mb4_general_ci
//Sprint表示一个迭代周期
type Sprint struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(100);
	Name string
	//StartDay field:startDay int;
	StartDay int
	//EndDay field:endDay int;
	EndDay int
	//Creator field:creator int;
	Creator int
	//TeamId field:teamId int;
	TeamId int
	//OrgId field:orgId int;
	OrgId int
}

//Task table:Task Engine: InnoDB Collation: utf8mb4_general_ci
type Task struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(300);
	Name string
	//TeamId field:teamId int;
	TeamId int
	//Uid field:uid int;
	Uid int
	//Ct field:ct bigint;
	Ct int64
	//State field:state int;
	State int
	//Day field:day int;
	Day int
	//StartTime field:startTime int;
	StartTime int
	//Duration field:duration int;
	Duration int
}

//Team table:Team Engine: InnoDB Collation: utf8mb4_general_ci
type Team struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(50);
	Name string
	//Creator field:creator int;
	Creator int
	//Ct field:ct bigint;
	Ct int64
}

//TeamUser table:TeamUser Engine: InnoDB Collation: utf8mb4_general_ci
type TeamUser struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//TeamId field:teamId int; unique index:tuuni normal index:tuTeamId; fk:tuTeamId ref:Team.id
	TeamId int
	//Uid field:uid int; unique index:tuuni normal index:tuUid; fk:tuUid ref:User.id
	Uid int
	//Role field:role int;
	Role int
	//Ct field:ct bigint;
	Ct int64
}

//User table:User Engine: InnoDB Collation: utf8mb4_general_ci
type User struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Name field:name varchar(30);唯一
	Name string
	//Icon1 field:icon1 varchar(100);
	Icon1 string
	//Icon2 field:icon2 varchar(100);
	Icon2 string
	//Icon3 field:icon3 varchar(100);
	Icon3 string
	//Ct field:ct bigint;
	Ct int64
}

//UserPrivate table:UserPrivate Engine: InnoDB Collation: utf8mb4_general_ci
type UserPrivate struct {
	//Id field:id int; unique index:PRIMARY;
	Id int
	//Uid field:uid int; unique index:upuid; fk:upuid ref:User.id
	Uid int
	//Password field:password varchar(32);
	Password string
	//Email field:email varchar(100); unique index:upemail;
	Email string
	//Mobile field:mobile varchar(20);
	Mobile string
	//Ct field:ct bigint;
	Ct int64
}

